System administrators can execute custom SQL scripts by first setting up report specifications. The benefit of executing a SQL script in this method is that the script can be automated from the iMIS front-end and report driven.
1. Select Utilities> Report Specs.
2. Select a report from the SYSTEM-System Setup group to clone.
3. Click the Clone button.
4. Enter a System, Category, Title and Description.
5. Click the Parameters button.
6. Enter SQLExec/240 in the Control Procedure box.
7. Enter MUST_BE_DBO,SHOW_SQL in the Options box.
8. Substitute the script in the Parameters box on the Detail Report Parameters window
Note: Place your cursor in the Parameters box and press CTRL+Z or click the Zoom button to open the parameters window.
9. Click OK to accept the changes. You can now execute the script from the Utilities> Reports & Queries window from within iMIS.
10. Click Run to execute the command. iMIS prompts you to confirm the action Updates Functional Title.
11. Click Yes to execute the script.
Example: Select a Report from the SYSTEM-System Setup.
Example: Enter MUST_BE_DBO,SHOW_SQL in the Options box.
Example: Substitute the script in the Parameters box.
Example: You can now execute the script.